package com.css.fxfzypg.modules.baseData.repository;

import com.css.fxfzypg.modules.baseData.dto.HouseDTO;
import com.css.fxfzypg.modules.baseData.queryParams.HouseQueryParams;
import com.css.fxfzypg.modules.baseData.entity.HouseEntity;
import org.springframework.data.domain.Page;

import java.sql.Timestamp;
import java.util.List;
import java.util.Map;

/**
 * @author y1fan
 * @create 2022-08-12 12:09
 */
public interface HouseRepository {
    HouseEntity getHouseById(String id);

    void updateHouse(HouseDTO houseDTO);

    Map<String,Object> getAllHouseByParams(HouseQueryParams queryParams, int curPage, int pageSize);

    void deleteHouse(List<String> list);

    void importExcel(HouseEntity houseEntity);

    HouseEntity findPeoByProAndCityAndPre(String province, String city, String prefecture);

    void save(HouseEntity houseEntity);

    HouseEntity getHouse(String province, String city, String prefecture);

    Integer countByCounty(String province, String city, String county);
    Integer countByCity(String province, String city);
    Integer countByProvince(String province);

    Integer countByProvinceAndYear(String provinceName, String taskYear);
}
